package com.qijia.travel.common;

public class SqlMappedId {

	/**
	 * 旅行社
	 */
	public final static String AGENCY_MISSION = "agency_mission";
	
	/**
	 * 导游
	 */
	public final static String GUIDE = "guide";
	
	/**
	 * 导游账号
	 */
	public final static String GUIDE_ACCOUNT = "guide_account";
	
	/**
	 * 导游状态
	 */
	public final static String GUIDE_STATUS = "guide_status";
	
	/**
	 * 状态名称
	 */
	public final static String STATUS = "status";
	
	/**
	 * 旅游团细节
	 */
	public final static String TOURIST_GROUP_DETAI = "tourist_group_detail";
	
	/**
	 * 旅游团创利
	 */
	public final static String TOURIST_GROUP_PROFIT = "tourist_group_profit";
	
	/**
	 * 旅游团奖金
	 */
	public final static String TOURIST_GROUP_REWARD = "tourist_group_reward";
	
	/**
	 * 旅游团
	 */
	public final static String TOURIST_GROUP = "tourist_group";
	
	/**
	 * 团队_导游
	 */
	public final static String TREAM_GUIDE = "tream_guide";
	
	/**
	 * 团队
	 */
	public final static String TREAM = "tream";
	
	/**
	 * 操作记录
	 */
	public final static String ACC_LOG = "acc_log";
	
	/**
	 * 收入支出
	 */
	public final static String TOURIST_EXPENDITURE = "tourist_expenditure";
	
	/**
	 * 收入支出
	 */
	public final static String CONSUMPTION = "tourist_consumption";
	
	
	public final static String selectByPrimaryKey = "selectByPrimaryKey";
	
	public final static String selectByExample = "selectByExample";
	
	public final static String deleteByPrimaryKey = "deleteByPrimaryKey";
	
	public final static String deleteByExample = "deleteByExample";
	
	public final static String insert = "insert";
	
	public final static String updateByPrimaryKey = "updateByPrimaryKey";
	
	public final static String updateByPrimaryKeySelective = "updateByPrimaryKeySelective";
	
	public final static String countByExample = "countByExample";
	
	public final static String selectPageByExample = "selectPageByExample";
	
	public final static String countByPageExample = "countByPageExample";
	
	/**
	 * 获取表结构
	 */
	public final static String selectTableStatus = TOURIST_GROUP_DETAI+".selectTableStatus";
	
	public final static String statisticsByPageExample = "Statistics";
	
	public final static String StatisticsCountByExample = "StatisticsCountByExample";
	
	/**
	 * 统计出团数、获利、奖励(必须为完成状态)
	 */
	public final static String StatisticsCount = "StatisticsCount";
	
	/**
	 * 统计出团数(未完成也包括在内)
	 */
	public final static String StatisticsUnCompleteCount = "StatisticsUnCompleteCount";
	
	/**
	 * 统计收入支出
	 */
	public final static String sumExpenditureByExample  ="sumExpenditureByExample";

}
